﻿CREATE PROCEDURE [dbo].[sp_Get_AccountWithOrder]
	@PeroidYear varchar(4), 
	@PeroidMonth varchar(2)
AS
	select o.AccountID from dbo.Orders o
	where o.PeroidYear = @PeroidYear and o.PeroidMonth = @PeroidMonth and o.IsPurchased = 1